/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : ers

 Target Server Type    : MySQL
 Target Server Version : 80020
 File Encoding         : 65001

 Date: 03/07/2022 21:12:13
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '商品ID',
  `title` varchar(200) NOT NULL COMMENT '商品标题',
  `url` varchar(200) NOT NULL COMMENT '商品图片路径',
  `price` decimal(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品单价',
  `is_enable` char(2) NOT NULL DEFAULT '0' COMMENT '是否启用商品,0:未启用,1:启用',
  `product_type_id` bigint unsigned NOT NULL COMMENT '商品类型id',
  `sale` bigint unsigned DEFAULT '0' COMMENT '销量',
  `description` varchar(200) DEFAULT NULL COMMENT '商品的描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='商品信息';

-- ----------------------------
-- Records of product
-- ----------------------------
BEGIN;
INSERT INTO `product` VALUES (1, '凉拌茄子', 'http://localhost:8080/images/57a76a1e-a58d-4164-af1b-dd689e784a6a.png', 15.00, '1', 11, 1001, '长茄子500g、大蒜20g、小香葱适量、香菜适量、红椒半个、干红辣椒适量、芝麻适量、盐适量、糖适量、味精适量、生抽适量、醋适量、油适量、花椒适量');
INSERT INTO `product` VALUES (2, '凉拌木耳', 'http://localhost:8080/images/8e4f8256-b7a7-456d-baf2-edda40bbb531.png', 15.00, '1', 12, 1012, '木耳、凉拌醋、凉拌酱油、生姜、青红椒、精盐、花椒油、白糖，食油');
INSERT INTO `product` VALUES (3, '雪花啤酒', 'http://localhost:8080/images/7b366b04-7be8-4423-995b-d30faed24f4c.png', 8.00, '1', 13, 10222, '泡沫丰富洁白如雪，口味持久溢香似花');
INSERT INTO `product` VALUES (4, '二锅头', 'http://localhost:8080/images/ba53a573-3693-4980-99de-9bb78521068e.png', 23.00, '1', 14, 10000, '');
INSERT INTO `product` VALUES (5, '雪碧', 'http://localhost:8080/images/7b5a308b-101b-46ff-8a23-23293dbf2cb7.png', 3.00, '1', 15, 2000, '1111');
INSERT INTO `product` VALUES (7, '可乐', 'http://localhost:8080/images/b06158ec-aeae-4e4c-9bbb-dbdb9a5e078e.png', 3.00, '1', 16, 12121, '1111');
INSERT INTO `product` VALUES (8, '红糖糍粑', 'http://localhost:8080/images/2f3a5a98-e2f5-4f48-8091-cc9cf7ff6b72.png', 12.00, '1', 17, 1250, '红糖');
INSERT INTO `product` VALUES (9, '南瓜饼', 'http://localhost:8080/images/efec208e-8e72-4a5c-b333-4fcee92bba0f.png', 12.00, '1', 18, 2530, '南瓜');
INSERT INTO `product` VALUES (10, '宫保日本豆腐', 'http://localhost:8080/images/d0d47bde-7d7f-4303-9ad3-ef095c1d4d38.png', 15.50, '1', 19, 2140, '日本豆腐,虾仁');
INSERT INTO `product` VALUES (11, '麻婆豆腐', 'http://localhost:8080/images/89bb1a28-54f6-435c-a3f2-3f11ba1fd1e8.png', 15.00, '1', 20, 4500, '豆腐,葱花');
INSERT INTO `product` VALUES (12, '粉蒸肉', 'http://localhost:8080/images/af1a277c-56ca-4811-bbe4-2208895e6b06.png', 25.00, '1', 21, 1511, '猪肉,羊肉');
INSERT INTO `product` VALUES (13, '老盐菜烧白', 'http://localhost:8080/images/ce508d37-2bb1-4ae6-b237-a645057921bd.png', 18.80, '1', 22, 23131, '猪五花');
INSERT INTO `product` VALUES (14, '清炒空心菜', 'http://localhost:8080/images/531fe8e4-1878-4ac2-bcad-142a30fb1fd7.png', 14.00, '1', 23, 4210, '空心菜');
INSERT INTO `product` VALUES (15, '奶油蛋糕', 'http://localhost:8080/images/c6d13b91-61e5-4f30-ac88-03b22e571ce4.png', 14.00, '1', 24, 2510, '植物奶油');
INSERT INTO `product` VALUES (16, '牛肉汤锅', 'http://localhost:8080/images/c90f44f8-a02f-479b-8897-cb23af164c17.png', 108.00, '1', 25, 540, '牛肉,白萝卜,牛肉丸子');
INSERT INTO `product` VALUES (17, '披萨', 'http://localhost:8080/images/22130244-ba0a-4406-a6af-4f2143d7da50.png', 35.50, '1', 25, 140, '火腿粒');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
